package cn.yuanqiao.archive.Identify.mapper;/**
 * @author 赵常飞
 * @date 2023/12/6 9:56
 */

import cn.yuanqiao.archive.Identify.domain.TenantYqMjjdFolderDa;
import cn.yuanqiao.archive.Identify.domain.TenantYqMjjdJob;
import cn.yuanqiao.archive.Identify.domain.TenantYqMjjdJobDa;
import cn.yuanqiao.archive.Identify.domain.TenantYqMjjdTask;
import cn.yuanqiao.archive.appManager.domain.TenantSysDictData;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *@Author: 赵常飞
 *@Date: 2023/12/6 9:56
 *@Description:
 *@Note:
 */
public interface MiJiIdentifyMapper {
    int createMjjdJobTable(@Param("tableName") String tableName);

    int createMjjdJobDaTable(@Param("tableName") String tableName);

    int createMjjdTask(@Param("tableName")String tableName);

    int createMjjdFolderDaTable(@Param("tableName") String tableName);

    int createKfjdItemFolderTable(@Param("tableName") String tableName);

    public List<Map<String, Object>> getlist(@Param("fields") String fields,@Param("tablename") String tablename,@Param("bgqxgqsql") String bgqxgqsql,@Param("lczsql") String lczsql,@Param("tiaojian") String tiaojian,@Param("orderstr") String orderstr,@Param("orderfield") String orderfield);

    int addtask(TenantYqMjjdTask task);

    int addjob(TenantYqMjjdJob mijijdJob);

    Map<String, Object> getjobinfo(TenantYqMjjdJob yqMjjdJob);

    int updatetask(TenantYqMjjdTask task);

    int updatejobinfo(TenantYqMjjdJob yqmjjdJob);

    int insertda(TenantYqMjjdJobDa yqmjjdJobDa);

    int insertfolderda(TenantYqMjjdFolderDa yqmjjdFolderDa);

    List<TenantYqMjjdJobDa> getyqKfjdJobDabyrenwuid(@Param("renwuid")Long renwuid,@Param("tableName") String tableName);

    String getmaxjnjmj(@Param("tableName")String tableName,@Param("renwuid") Long renwuid,@Param("jiandingfield")String jiandingfield,@Param("daid") Long daid);

    int updatedatable1(TenantYqMjjdJobDa jobDa);

    int updatefolderda1(TenantYqMjjdFolderDa folderDa);

    int shendingtijiao(TenantYqMjjdJobDa yqmjjdJobDa);

    int shendingtijiaofolderda(TenantYqMjjdFolderDa folderDa);

    int updateresult(@Param("maintableName")String maintableName, @Param("mainfield")String mainfield,@Param("subTableName") String subTableName, @Param("subfield")String subfield,@Param("idsql") String idsql,@Param("jobdatable")String jobdatable,@Param("renwuid")String renwuid,@Param("nowdate")String nowdate);

    List<Map<String, Object>> gettongjibyjobname(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("bgqxs")List<TenantSysDictData> bgqxs);

    List<Map<String, Object>> gettongjibyuserchushen(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("userid")String userid,@Param("bgqxs")List<TenantSysDictData> bgqxs);

    List<Map<String, Object>> gettongjibyuserfushen(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("userid")String userid,@Param("bgqxs")List<TenantSysDictData> bgqxs);

    List<Map<String, Object>> gettongjibycate(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("bgqxs")List<TenantSysDictData> bgqxs);

    List<Map<String, Object>> gettongjibyqzh(@Param("hdda")String hdda, @Param("jobtable")String jobtable,@Param("jobdatable") String jobdatable, @Param("folderda")String folderda, @Param("catetable") String catetable,@Param("bgqxs")List<TenantSysDictData> bgqxs);

    List<Map<String, Object>> exportjobdadata(@Param("renwuid")Long renwuid,@Param("tableName")String tableName, @Param("searchtable")String searchtable, @Param("fields")String fields,@Param("orderstr") String orderstr,@Param("ids") List ids,@Param("dicttable")String dicttable);

    int jiandingagin(@Param("maintableName")String maintableName, @Param("mainfield")String mainfield,@Param("subTableName") String subTableName, @Param("subfield")String subfield,@Param("idsql") String idsql);
}